TankTemperatureSensor

Entity Definition

Logical Name : TankTemperatureSensor
Physical Name : AS_SNSR_TEMP

A device that is housed in the Tank and periodically (or on demand) returns temperature readings for the FuelItem that is stored there.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer Tank(LO_TNK)
TankID (FK)(PK) A unique identifier for this Tank ID_TNK Identity integer Tank(LO_TNK)
TankTemperatureSensorID (PK) A unique identifier for the TemperatureSensor in a particular Tank ID_SNSR_TNK_TEMP Identity integer
Height The height of the temperature sensor from the bottom of the Tank QL_HT Quantity DECIMAL(9,3)

Relationships

Parent Entity Verb Phrase Child Entity
Tank has TankTemperatureSensor
TankTemperatureSensor records TankTemperatureReading

Logical Views containing TankTemperatureSensor

Logical View
Logical 20000 - Forecourt Macro View
Logical 20050 - Forecourt Tank Gauge View